﻿CREATE TABLE [ODData].[TimeSeries] (
    [ObservationID]        INT      IDENTITY (1, 1) NOT NULL,
    [SeriesID]             INT      NOT NULL,
    [LocalDateTime]        DATETIME NOT NULL,
    [UTCOffsetHours]       REAL     NOT NULL,
    [ObservedValue]        REAL     NOT NULL,
    [VerticalOffset]       REAL     NOT NULL,
    [VerticalOffsetUnitID] INT      NOT NULL,
    [VerticalReferenceID]  INT      NOT NULL,
    [ObservedCategoryID]   INT      NOT NULL,
    [CensorID]             INT      NOT NULL,
    [QualityIndicatorID]   INT      NOT NULL
);

